﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Main.master" AutoEventWireup="true" CodeBehind="ThongKeTheoLop.aspx.cs" Inherits="WTSQCB.ThongKeTheoLop" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
    <p>
        pn</p>
    <p>
        Thống kê theo lớp</p>
    <p>
        &nbsp; Mã lớp:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:TextBox ID="tbMalop" runat="server"></asp:TextBox>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:WebDiemTSQCBConnectionString %>" SelectCommand="XemLop" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:Parameter Name="malop" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:Button ID="btnXem" runat="server" OnClick="btnXem_Click" Text="Xem" Width="80px" />
    </p>
    <p>
        <asp:GridView ID="grdThongKe" runat="server" AutoGenerateColumns="False" DataKeyNames="MaLop" DataSourceID="SqlDataSource2" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" Width="881px" AllowPaging="True" AllowSorting="True" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4">
            <Columns>
                <asp:BoundField DataField="MaLop" HeaderText="MaLop" ReadOnly="True" SortExpression="MaLop" />
                <asp:BoundField DataField="TenLop" HeaderText="TenLop" SortExpression="TenLop" />
                <asp:BoundField DataField="TenDaiDoi" HeaderText="TenDaiDoi" SortExpression="TenDaiDoi" />
                <asp:BoundField DataField="TenChuyenNganh" HeaderText="TenChuyenNganh" SortExpression="TenChuyenNganh" />
                <asp:BoundField DataField="TenHeDaoTao" HeaderText="TenHeDaoTao" SortExpression="TenHeDaoTao" />
                <asp:BoundField DataField="TenTrinhDo" HeaderText="TenTrinhDo" SortExpression="TenTrinhDo" />
            </Columns>
            <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
            <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
            <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
            <RowStyle BackColor="White" ForeColor="#003399" />
            <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
            <SortedAscendingCellStyle BackColor="#EDF6F6" />
            <SortedAscendingHeaderStyle BackColor="#0D4AC4" />
            <SortedDescendingCellStyle BackColor="#D6DFDF" />
            <SortedDescendingHeaderStyle BackColor="#002876" />
        </asp:GridView>
    </p>
    <p>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:WebDiemTSQCBConnectionString %>" SelectCommand="XemLop" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:ControlParameter ControlID="tbMalop" Name="malop" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
</asp:Content>
